﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="showevents.aspx.vb" Inherits="felixfinalproject2.showevents" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder2" runat="server">
<br/>
<center>
    <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1" 
    AutoGenerateColumns="False" DataKeyNames="ID" CellPadding="4" 
        ForeColor="#333333" GridLines="None">
        <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
    <Columns>
        <asp:BoundField DataField="eventname" HeaderText="Event" 
            SortExpression="eventname" />
        <asp:BoundField DataField="venue" HeaderText="Venue" SortExpression="venue" />
        <asp:BoundField DataField="cars_to_use" HeaderText="Event Cars" 
            SortExpression="cars_to_use" />
        <asp:BoundField DataField="event_planner" HeaderText="Event Planner" 
            SortExpression="event_planner" />
        <asp:BoundField DataField="date_and_time" HeaderText="Date and Time" 
            SortExpression="date_and_time" />
    </Columns>
        <EditRowStyle BackColor="#999999" />
        <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
        <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
        <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
        <SortedAscendingCellStyle BackColor="#E9E7E2" />
        <SortedAscendingHeaderStyle BackColor="#506C8C" />
        <SortedDescendingCellStyle BackColor="#FFFDF8" />
        <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:mercedesbenzconnectionstring %>" 
    ProviderName="<%$ ConnectionStrings:mercedesbenzconnectionstring.ProviderName %>" 
    
    SelectCommand="SELECT [ID], [eventname], [venue], [cars_to_use], [event_planner], [date_and_time] FROM [events]"></asp:SqlDataSource>
<br />
<asp:SqlDataSource ID="SqlDataSource2" runat="server" 
    ConnectionString="<%$ ConnectionStrings:mercedesbenzconnectionstring %>" 
    ProviderName="<%$ ConnectionStrings:mercedesbenzconnectionstring.ProviderName %>" 
    
    SelectCommand="SELECT * FROM [events] WHERE ([ID] = ?)">
    <SelectParameters>
        <asp:QueryStringParameter Name="ID" QueryStringField="ID" Type="Int32" />
    </SelectParameters>
</asp:SqlDataSource>
</center>
</asp:Content>
